Hilarious uses of Excel
نویسنده
چکیده
著者ら [1]は,2011年の東日本大震災後に見られ た情報リテラシーにかかわる問題点を論じた際に, 公開されたデータの機械可読性の低さを指摘した。 それらのデータは,Excel に入力されていながら, 公開情報が PDF だけであったり,時にはデータ抽 出禁止の設定がなされていたり画像化されていたり して,集約や再解析にたいへん手間がかかった。 しかし,震災データに限らず,政府統計の総合窓 口 e-Stat [3] や自治体などで公開されているデータ を調べるにつれて,そもそも Excelへの入力の段階 でデータの再利用を考えず,罫線を多用した紙の帳 票作成を最終目的とするものが多いことに気づい た。こうしたデータは,PDFでなく Excelファイル (またはそれから生成した CSVファイル)で公開さ れたとしても,データを再解析するには余計な手間 がかかる。 こうした巧妙だがデータとしての再利用性の低い
منابع مشابه
An Algorithmic Approach for Solving ETSP Using Premium Solver Platform
Spreadsheet software, notably Microsoft Excel©, can be used very effectively for analyzing logistics and supply chain issues. Spreadsheet allow analysis from many different perspectives and can be modified and enhanced to reflect new situations and options. Our purpose in this article is to demonstrate the efficiency of a problemsolving algorithm that uses Microsoft Excel add-in tools Premium S...
متن کاملImplementation of Non-java Based Interfaces to Embed Existing Models in Spatial Decision Support Systems - Case Study: Integration of Ms Excel-models in Iwegs -
This paper shows the programming and usage of computer based interfaces to embed models in modern SDSSs. The special focus is on the development and implementation of non-Java based interfaces which couple already existing Microsoft (MS) Excel-based models to individual designed SDSSs. To access MS Excel files within these developed systems, Java API POI-HSSF (by Jakarta) is used. HSSF provides...
متن کاملARS-Media for Excel: A Spreadsheet Tool for Calculating Media Recipes Based on Ion-Specific Constraints
ARS-Media for Excel is an ion solution calculator that uses "Microsoft Excel" to generate recipes of salts for complex ion mixtures specified by the user. Generating salt combinations (recipes) that result in pre-specified target ion values is a linear programming problem. Excel's Solver add-on solves the linear programming equation to generate a recipe. Calculating a mixture of salts to genera...
متن کاملDesign and Use of the Microsoft Excel Solver
We describe the design and use of the spreadsheet optimizer that is bundled with Microsoft Excel. We explain why we and Microsoft made certain choices in designing its user interface, model processing, and solution algorithms for linear, nonlinear and integer programs. We describe some of the common pitfalls encountered by users, and remedies available in the latest version of Microsoft Excel. ...
متن کاملAge-decomposition of a difference between two populations for any life-table quantity in Excel
We provide a simple VBA/Excel program that decomposes by age a difference between two values of a life-table based quantity. For example, one might want to know what are contributions of different ages into the total difference between two populations in: values of life expectancy at birth or of temporary life expectancy between exact ages 20 and 65 or of standard deviation of ages at death ove...
متن کامل